package com.worthtech.billportal.dao;

import java.util.HashMap;
import java.util.List;

import com.worthtech.billportal.bean.BillInfoOracle;
import com.worthtech.billportal.bean.CsAccountInfo;
import com.worthtech.billportal.bean.CsPepPayinfo;
import com.worthtech.billportal.bean.CsPosBin;
import com.worthtech.billportal.bean.CsPosPara;
import com.worthtech.billportal.bean.WtPepPayinfo;
import com.worthtech.billportal.exception.SCException;

public interface BillOracleDAO {
	
	public BillInfoOracle saveBill(BillInfoOracle billInfoOracle)
	throws SCException;
	public int insertBysql(String sql);
	public void save(CsAccountInfo c);
	public void delete(CsAccountInfo c);
	public List getListByHQL(String tableName, int startPage, int perNo,
			String orderby);
	public void updatePayinfo(String orgid);
	public void save(WtPepPayinfo w);
	public void save(CsPepPayinfo c);
	public List findbySql(String sql);
	public void delete(WtPepPayinfo w);
	public void delete(CsPepPayinfo c);
	public String getCount(String tableName, String condition);
	public String getSum(String list,String tableName, String condition);
	public List getListBySQL(String tableName, int startPage, int perNo,
			String orderby);
	public String getCountBySQL(String tableName, String condition) ;
	public String getSumBySQL(String list,String tableName, String condition);;
	public String getbySql(String sql);
	public HashMap getDatainfo(String tablename, String code,String tj, String start,
			String end);
	public void save(CsPosPara c);
	public void delete(CsPosPara c);
	public void save(CsPosBin c);
	public HashMap getDatainfo(String tablename,String code,String start,String end);
	public void delbin();
	public void toSql(String sql) throws Exception;
	public void savebin()throws Exception;
	public void saveBin(String head,String iss,String leng,String card);
}
